package com.site.service;

import com.site.pojo.ReserveType;
import com.site.vo.ReserveTypeAndGoodsVO;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

/**
 * FileName: ReserveTypeService.java
 * 仓库分类表Service
 *
 * @author 田尚忠
 * @Date    2021/11/28
 * @version 1.00
 */
public interface ReserveTypeService {
    /*查询方法*/
        //查询全部
        List<ReserveType> selectAll() throws SQLException;
        //通过id查询
        ReserveType selectById(int id) throws SQLException;
    /*增加方法*/
        boolean addReserveType(ReserveType reserveType);
        boolean addReserveType(Connection conn,ReserveType reserveType);
    /*删除方法*/
        //通过id删除
        boolean delReserveTypeById(int id);
        boolean delReserveTypeById(Connection conn,int id);

        //通过状态进行删除
        boolean delReserveTypeByState(int state);
        boolean delReserveTypeByState(Connection conn,int state);
    /*修改方法*/
        //通过id进行修改
        boolean updateReserveTypeByid(int id,ReserveType reserveType);
        boolean updateReserveTypeByid(Connection conn,int id,ReserveType reserveType);


        //仓库所有信息
        List<ReserveTypeAndGoodsVO> allVOCableSize() throws SQLException;
        List<ReserveTypeAndGoodsVO> allVOCircuitBoardSize() throws SQLException;
        List<ReserveTypeAndGoodsVO> allVOElectricWireSize() throws SQLException;


        //按条件查询
        List<ReserveTypeAndGoodsVO> selectgetByrtidAndrid(int rtid,int rid) throws SQLException;
}
